Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$RULE

`V$RULE` displays rule statistics. This view has a row for every rule loaded into shared memory.

Column | Datatype | Description
--- | --- | ---
`RULE_SET_OBJECT_ID` | `NUMBER` | Rule set object ID
`EVALUATION_CONTEXT_OBJECT_ID` | `NUMBER` | Evaluation context object ID
`RULE_OWNER` | `VARCHAR2(64)` | Owner of the rule
`RULE_NAME` | `VARCHAR2(64)` | Name of the rule
`RULE_CONDITION` | `VARCHAR2(64)` | Rule condition
`TRUE_HITS` | `NUMBER` | Number of times the rule evaluated to `TRUE`
`MAYBE_HITS` | `NUMBER` | Number of times the rule evaluated to `MAYBE`
`SQL_EVALUATIONS` | `NUMBER` | Number of evaluations of the rule that were performed by issuing SQL